# encoding: utf-8
import datetime
from south.db import db
from south.v2 import SchemaMigration
from django.db import models

class Migration(SchemaMigration):
    
    def forwards(self, orm):
        
        # Adding model 'MenuType'
        db.create_table('oa_menutype', (
            ('icon', self.gf('django.db.models.fields.CharField')(max_length=20)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('seq', self.gf('django.db.models.fields.IntegerField')()),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=30)),
        ))
        db.send_create_signal('oa', ['MenuType'])

        # Adding model 'Menu'
        db.create_table('oa_menu', (
            ('operation_function', self.gf('django.db.models.fields.CharField')(max_length=20)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=30)),
            ('seq', self.gf('django.db.models.fields.IntegerField')()),
            ('menu_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['oa.MenuType'])),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('icon', self.gf('django.db.models.fields.CharField')(max_length=20)),
        ))
        db.send_create_signal('oa', ['Menu'])

        # Adding model 'Role'
        db.create_table('oa_role', (
            ('description', self.gf('django.db.models.fields.CharField')(max_length=100)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=30)),
        ))
        db.send_create_signal('oa', ['Role'])

        # Adding M2M table for field menus on 'Role'
        db.create_table('oa_role_menus', (
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
            ('role', models.ForeignKey(orm['oa.role'], null=False)),
            ('menu', models.ForeignKey(orm['oa.menu'], null=False))
        ))
        db.create_unique('oa_role_menus', ['role_id', 'menu_id'])

        # Adding model 'User'
        db.create_table('oa_user', (
            ('insert_date', self.gf('django.db.models.fields.DateField')()),
            ('password', self.gf('django.db.models.fields.CharField')(max_length=30)),
            ('activable', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=30)),
        ))
        db.send_create_signal('oa', ['User'])

        # Adding M2M table for field roles on 'User'
        db.create_table('oa_user_roles', (
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
            ('user', models.ForeignKey(orm['oa.user'], null=False)),
            ('role', models.ForeignKey(orm['oa.role'], null=False))
        ))
        db.create_unique('oa_user_roles', ['user_id', 'role_id'])

        # Adding model 'Contact'
        db.create_table('oa_contact', (
            ('fax', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('code', self.gf('django.db.models.fields.CharField')(unique=True, max_length=20)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=30)),
            ('person', self.gf('django.db.models.fields.CharField')(max_length=10, null=True)),
            ('phone', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('address', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('oftype', self.gf('django.db.models.fields.CharField')(max_length=5)),
        ))
        db.send_create_signal('oa', ['Contact'])

        # Adding model 'ContainerType'
        db.create_table('oa_containertype', (
            ('max_volume', self.gf('django.db.models.fields.IntegerField')(null=True)),
            ('max_weigth', self.gf('django.db.models.fields.IntegerField')(null=True)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('size', self.gf('django.db.models.fields.CharField')(max_length=30)),
        ))
        db.send_create_signal('oa', ['ContainerType'])

        # Adding model 'Currency'
        db.create_table('oa_currency', (
            ('rate', self.gf('django.db.models.fields.DecimalField')(max_digits=7, decimal_places=3)),
            ('code', self.gf('django.db.models.fields.CharField')(max_length=5)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
        ))
        db.send_create_signal('oa', ['Currency'])

        # Adding model 'Feetype'
        db.create_table('oa_feetype', (
            ('default_currencytype', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['oa.Currency'])),
            ('code', self.gf('django.db.models.fields.CharField')(max_length=10)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=20)),
        ))
        db.send_create_signal('oa', ['Feetype'])

        # Adding model 'Country'
        db.create_table('oa_country', (
            ('phone', self.gf('django.db.models.fields.CharField')(max_length=20)),
            ('code', self.gf('django.db.models.fields.CharField')(max_length=30)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=30)),
        ))
        db.send_create_signal('oa', ['Country'])

        # Adding model 'Port'
        db.create_table('oa_port', (
            ('code', self.gf('django.db.models.fields.CharField')(max_length=20)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=50)),
        ))
        db.send_create_signal('oa', ['Port'])

        # Adding model 'PackType'
        db.create_table('oa_packtype', (
            ('code', self.gf('django.db.models.fields.CharField')(max_length=20)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=50)),
        ))
        db.send_create_signal('oa', ['PackType'])

        # Adding model 'Orders'
        db.create_table('oa_orders', (
            ('h_payment_type', self.gf('django.db.models.fields.CharField')(max_length=10, null=True)),
            ('booking_proxy_company_name', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('client_company', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('insert_date', self.gf('django.db.models.fields.DateTimeField')()),
            ('shipping_company_phone', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('client_fax', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('consignee', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
            ('operator', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', to=orm['oa.User'])),
            ('english_name', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('client_phone', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('cargo_collection_code', self.gf('django.db.models.fields.CharField')(max_length=10, null=True)),
            ('destination_place', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('update_date', self.gf('django.db.models.fields.DateTimeField')()),
            ('small_packing_type', self.gf('django.db.models.fields.CharField')(max_length=10, null=True)),
            ('h_release_way', self.gf('django.db.models.fields.IntegerField')(null=True)),
            ('booking_date', self.gf('django.db.models.fields.DateField')(null=True)),
            ('info_summy', self.gf('django.db.models.fields.CharField')(max_length=70, null=True)),
            ('chinese_name', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('large_number', self.gf('django.db.models.fields.IntegerField')(null=True)),
            ('shipping_date', self.gf('django.db.models.fields.DateField')(null=True)),
            ('container_type', self.gf('django.db.models.fields.IntegerField')(null=True)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('booking_proxy_company_phone', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('client_person', self.gf('django.db.models.fields.CharField')(max_length=10, null=True)),
            ('m_release_way', self.gf('django.db.models.fields.IntegerField')(null=True)),
            ('saleman', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', to=orm['oa.User'])),
            ('cargo_collection_name', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('shipping_company_code', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('cargo_collection_type', self.gf('django.db.models.fields.IntegerField')(null=True)),
            ('remark', self.gf('django.db.models.fields.TextField')(null=True)),
            ('large_packing_type', self.gf('django.db.models.fields.CharField')(max_length=10, null=True)),
            ('client_code', self.gf('django.db.models.fields.CharField')(max_length=10)),
            ('arrival_date', self.gf('django.db.models.fields.DateField')(null=True)),
            ('m_payment_type', self.gf('django.db.models.fields.CharField')(max_length=10, null=True)),
            ('volume', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=7, decimal_places=3)),
            ('loading_port', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('order_code', self.gf('django.db.models.fields.CharField')(max_length=30)),
            ('booking_proxy_company_person', self.gf('django.db.models.fields.CharField')(max_length=10, null=True)),
            ('destination_port', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('receipt_place', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('small_number', self.gf('django.db.models.fields.IntegerField')(null=True)),
            ('booking_proxy_company_fax', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('container_info', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('gross_weight', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=7, decimal_places=3)),
            ('shipper', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
            ('shipping_mark', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('shipping_company_fax', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('mbl_code', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)),
            ('shipping_company_person', self.gf('django.db.models.fields.CharField')(max_length=10, null=True)),
            ('status', self.gf('django.db.models.fields.IntegerField')()),
            ('booking_proxy_company_code', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('shipping_company_name', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('unloading_port', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('notifier', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
        ))
        db.send_create_signal('oa', ['Orders'])

        # Adding model 'OrderHbl'
        db.create_table('oa_orderhbl', (
            ('consignee', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
            ('packing_type', self.gf('django.db.models.fields.CharField')(max_length=10, null=True)),
            ('numbers', self.gf('django.db.models.fields.IntegerField')(null=True)),
            ('english_name', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('destination_place', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('issue_date', self.gf('django.db.models.fields.DateField')(null=True)),
            ('info_summy', self.gf('django.db.models.fields.CharField')(max_length=70, null=True)),
            ('shipping_mark', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('shipping_date', self.gf('django.db.models.fields.DateField')(null=True)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('payment_way', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)),
            ('transit_clause', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('lading_bill_way', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)),
            ('cargo_collection_name', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
            ('payment_address', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('volume', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=7, decimal_places=3)),
            ('loading_port', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('issue_address', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('shipper', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
            ('destination_port', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('receipt_place', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('container_info', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('gross_weight', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=7, decimal_places=3)),
            ('fee_description', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('sealing_number', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('order', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['oa.Orders'], unique=True)),
            ('shipping_name_number', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('issue_number', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('so', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)),
            ('unloading_port', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('notifier', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
        ))
        db.send_create_signal('oa', ['OrderHbl'])

        # Adding model 'OrderMbl'
        db.create_table('oa_ordermbl', (
            ('consignee', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
            ('packing_type', self.gf('django.db.models.fields.CharField')(max_length=10, null=True)),
            ('numbers', self.gf('django.db.models.fields.IntegerField')(null=True)),
            ('english_name', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('destination_place', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('issue_date', self.gf('django.db.models.fields.DateField')(null=True)),
            ('info_summy', self.gf('django.db.models.fields.CharField')(max_length=70, null=True)),
            ('shipping_mark', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('shipping_date', self.gf('django.db.models.fields.DateField')(null=True)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('payment_way', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)),
            ('transit_clause', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('lading_bill_way', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)),
            ('cargo_collection_name', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
            ('payment_address', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('volume', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=7, decimal_places=3)),
            ('loading_port', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('issue_address', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('shipper', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
            ('destination_port', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('receipt_place', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('container_info', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('gross_weight', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=7, decimal_places=3)),
            ('fee_description', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('sealing_number', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('mbl_code', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)),
            ('order', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['oa.Orders'], unique=True)),
            ('shipping_name_number', self.gf('django.db.models.fields.CharField')(max_length=50, null=True)),
            ('booking_number', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)),
            ('issue_number', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('so', self.gf('django.db.models.fields.CharField')(max_length=30, null=True)),
            ('unloading_port', self.gf('django.db.models.fields.CharField')(max_length=20, null=True)),
            ('notifier', self.gf('django.db.models.fields.CharField')(max_length=100, null=True)),
        ))
        db.send_create_signal('oa', ['OrderMbl'])

        # Adding model 'Bill'
        db.create_table('oa_bill', (
            ('count', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=7, decimal_places=3)),
            ('bill_name', self.gf('django.db.models.fields.CharField')(max_length=20)),
            ('order', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['oa.Orders'])),
            ('bill_code', self.gf('django.db.models.fields.CharField')(max_length=10)),
            ('currency', self.gf('django.db.models.fields.CharField')(max_length=10)),
            ('amount', self.gf('django.db.models.fields.DecimalField')(max_digits=7, decimal_places=2)),
            ('total', self.gf('django.db.models.fields.DecimalField')(default=0.0, max_digits=7, decimal_places=2)),
            ('type', self.gf('django.db.models.fields.IntegerField')(default=1)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
        ))
        db.send_create_signal('oa', ['Bill'])
    
    
    def backwards(self, orm):
        
        # Deleting model 'MenuType'
        db.delete_table('oa_menutype')

        # Deleting model 'Menu'
        db.delete_table('oa_menu')

        # Deleting model 'Role'
        db.delete_table('oa_role')

        # Removing M2M table for field menus on 'Role'
        db.delete_table('oa_role_menus')

        # Deleting model 'User'
        db.delete_table('oa_user')

        # Removing M2M table for field roles on 'User'
        db.delete_table('oa_user_roles')

        # Deleting model 'Contact'
        db.delete_table('oa_contact')

        # Deleting model 'ContainerType'
        db.delete_table('oa_containertype')

        # Deleting model 'Currency'
        db.delete_table('oa_currency')

        # Deleting model 'Feetype'
        db.delete_table('oa_feetype')

        # Deleting model 'Country'
        db.delete_table('oa_country')

        # Deleting model 'Port'
        db.delete_table('oa_port')

        # Deleting model 'PackType'
        db.delete_table('oa_packtype')

        # Deleting model 'Orders'
        db.delete_table('oa_orders')

        # Deleting model 'OrderHbl'
        db.delete_table('oa_orderhbl')

        # Deleting model 'OrderMbl'
        db.delete_table('oa_ordermbl')

        # Deleting model 'Bill'
        db.delete_table('oa_bill')
    
    
    models = {
        'oa.bill': {
            'Meta': {'object_name': 'Bill'},
            'amount': ('django.db.models.fields.DecimalField', [], {'max_digits': '7', 'decimal_places': '2'}),
            'bill_code': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
            'bill_name': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
            'count': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '7', 'decimal_places': '3'}),
            'currency': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'order': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['oa.Orders']"}),
            'total': ('django.db.models.fields.DecimalField', [], {'default': '0.0', 'max_digits': '7', 'decimal_places': '2'}),
            'type': ('django.db.models.fields.IntegerField', [], {'default': '1'})
        },
        'oa.contact': {
            'Meta': {'object_name': 'Contact'},
            'address': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
            'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '20'}),
            'fax': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'name': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
            'oftype': ('django.db.models.fields.CharField', [], {'max_length': '5'}),
            'person': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True'}),
            'phone': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'})
        },
        'oa.containertype': {
            'Meta': {'object_name': 'ContainerType'},
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'max_volume': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
            'max_weigth': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
            'size': ('django.db.models.fields.CharField', [], {'max_length': '30'})
        },
        'oa.country': {
            'Meta': {'object_name': 'Country'},
            'code': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'name': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
            'phone': ('django.db.models.fields.CharField', [], {'max_length': '20'})
        },
        'oa.currency': {
            'Meta': {'object_name': 'Currency'},
            'code': ('django.db.models.fields.CharField', [], {'max_length': '5'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'rate': ('django.db.models.fields.DecimalField', [], {'max_digits': '7', 'decimal_places': '3'})
        },
        'oa.feetype': {
            'Meta': {'object_name': 'Feetype'},
            'code': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
            'default_currencytype': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['oa.Currency']"}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'name': ('django.db.models.fields.CharField', [], {'max_length': '20'})
        },
        'oa.menu': {
            'Meta': {'object_name': 'Menu'},
            'icon': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'menu_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['oa.MenuType']"}),
            'name': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
            'operation_function': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
            'seq': ('django.db.models.fields.IntegerField', [], {})
        },
        'oa.menutype': {
            'Meta': {'object_name': 'MenuType'},
            'icon': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'name': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
            'seq': ('django.db.models.fields.IntegerField', [], {})
        },
        'oa.orderhbl': {
            'Meta': {'object_name': 'OrderHbl'},
            'cargo_collection_name': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
            'consignee': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
            'container_info': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'destination_place': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'destination_port': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'english_name': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'fee_description': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'gross_weight': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '7', 'decimal_places': '3'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'info_summy': ('django.db.models.fields.CharField', [], {'max_length': '70', 'null': 'True'}),
            'issue_address': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'issue_date': ('django.db.models.fields.DateField', [], {'null': 'True'}),
            'issue_number': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'lading_bill_way': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
            'loading_port': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'notifier': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
            'numbers': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
            'order': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['oa.Orders']", 'unique': 'True'}),
            'packing_type': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True'}),
            'payment_address': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'payment_way': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
            'receipt_place': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'sealing_number': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'shipper': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
            'shipping_date': ('django.db.models.fields.DateField', [], {'null': 'True'}),
            'shipping_mark': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'shipping_name_number': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'so': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
            'transit_clause': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'unloading_port': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'volume': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '7', 'decimal_places': '3'})
        },
        'oa.ordermbl': {
            'Meta': {'object_name': 'OrderMbl'},
            'booking_number': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
            'cargo_collection_name': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
            'consignee': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
            'container_info': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'destination_place': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'destination_port': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'english_name': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'fee_description': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'gross_weight': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '7', 'decimal_places': '3'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'info_summy': ('django.db.models.fields.CharField', [], {'max_length': '70', 'null': 'True'}),
            'issue_address': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'issue_date': ('django.db.models.fields.DateField', [], {'null': 'True'}),
            'issue_number': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'lading_bill_way': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
            'loading_port': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'mbl_code': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
            'notifier': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
            'numbers': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
            'order': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['oa.Orders']", 'unique': 'True'}),
            'packing_type': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True'}),
            'payment_address': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'payment_way': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
            'receipt_place': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'sealing_number': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'shipper': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
            'shipping_date': ('django.db.models.fields.DateField', [], {'null': 'True'}),
            'shipping_mark': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'shipping_name_number': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'so': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
            'transit_clause': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'unloading_port': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'volume': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '7', 'decimal_places': '3'})
        },
        'oa.orders': {
            'Meta': {'object_name': 'Orders'},
            'arrival_date': ('django.db.models.fields.DateField', [], {'null': 'True'}),
            'booking_date': ('django.db.models.fields.DateField', [], {'null': 'True'}),
            'booking_proxy_company_code': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'booking_proxy_company_fax': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'booking_proxy_company_name': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'booking_proxy_company_person': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True'}),
            'booking_proxy_company_phone': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'cargo_collection_code': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True'}),
            'cargo_collection_name': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'cargo_collection_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
            'chinese_name': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'client_code': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
            'client_company': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'client_fax': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'client_person': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True'}),
            'client_phone': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'consignee': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
            'container_info': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'container_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
            'destination_place': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'destination_port': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'english_name': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'gross_weight': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '7', 'decimal_places': '3'}),
            'h_payment_type': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True'}),
            'h_release_way': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'info_summy': ('django.db.models.fields.CharField', [], {'max_length': '70', 'null': 'True'}),
            'insert_date': ('django.db.models.fields.DateTimeField', [], {}),
            'large_number': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
            'large_packing_type': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True'}),
            'loading_port': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'm_payment_type': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True'}),
            'm_release_way': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
            'mbl_code': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
            'notifier': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
            'operator': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['oa.User']"}),
            'order_code': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
            'receipt_place': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'remark': ('django.db.models.fields.TextField', [], {'null': 'True'}),
            'saleman': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['oa.User']"}),
            'shipper': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
            'shipping_company_code': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'shipping_company_fax': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'shipping_company_name': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True'}),
            'shipping_company_person': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True'}),
            'shipping_company_phone': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'shipping_date': ('django.db.models.fields.DateField', [], {'null': 'True'}),
            'shipping_mark': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'small_number': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
            'small_packing_type': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True'}),
            'status': ('django.db.models.fields.IntegerField', [], {}),
            'unloading_port': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True'}),
            'update_date': ('django.db.models.fields.DateTimeField', [], {}),
            'volume': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '7', 'decimal_places': '3'})
        },
        'oa.packtype': {
            'Meta': {'object_name': 'PackType'},
            'code': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
        },
        'oa.port': {
            'Meta': {'object_name': 'Port'},
            'code': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
        },
        'oa.role': {
            'Meta': {'object_name': 'Role'},
            'description': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'menus': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['oa.Menu']", 'symmetrical': 'False'}),
            'name': ('django.db.models.fields.CharField', [], {'max_length': '30'})
        },
        'oa.user': {
            'Meta': {'object_name': 'User'},
            'activable': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'insert_date': ('django.db.models.fields.DateField', [], {}),
            'name': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
            'password': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
            'roles': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['oa.Role']", 'symmetrical': 'False'})
        }
    }
    
    complete_apps = ['oa']
